LPN linking

Use this transaction to perform the following actions:

  • Assign one or several stock lines to a license plate number (LPN) and store the LPN in a location. Each stock line includes the product characteristics (product code, location, status, lot, etc.).

  • Generate stock change movements and create a stock change document in Sage X3.

    Note - informationAn LPN can be a pallet, a box, a barrel or any kind of logistic container.

Prerequisites

In Sage X3, perform the actions described below.

Functional prerequisites

Mobile Automation setup (FUNADCSEARCH)

Open: Setup > Stock > Mobile Automation setup

  1. Go to the Stock search section.

  2. Select the Container operation flow type.

  3. Define the stock search filters that you want to use in this transaction. You can define up to 8 filters. These stock search filters are the same for the LPN linking, LPN unlinking, and LPN splitting transactions.

Note - informationIn these transactions, these filters do not display in the order in which you have defined them in the Mobile Automation setup function. They always display in the following order: Location, Lot, Sublot, Serial number (when the management mode is Received/Issued), Status, Packing unit, PAC/STK conversion factor, Identifier 1 and Identifier 2, Custom field 1 and Custom field 2.

Web service prerequisites

  1. Open: Administration > Web services > Classic SOAP pools configuration

    Stop the web service pool.

  2. Import/export templates (GESAOE)

    Open: Setup > Usage > Imports / exports > Import/export templates

    Validate the CWSLPNO import template.

  3. Web services (GESAWE)

    Open: Development > Script dictionary > Scripts > Web services

    Publish the AOWSIMPORT web service.

  4. Open: Administration > Web services > Classic SOAP pools configuration

    Start the web service pool.

How to link stock lines to an LPN

Open: LPN > LPN linking

To link stock lines to an LPN, enter information on 3 pages:

  • The initial page is used to select the destination LPN, and the product to be linked to the LPN.
  • The second page is used to select the product stock lines. From this page, you can also perform the following actions:
    • Display the stock line details
    • Enter the exact quantity to link to the LPN
  • The third page is used to validate the creation of the stock change document and validate the stock movement.

Operating mode

  1. On the initial page, check that the Change date and Site default values are correct.
  2. Scan, select or enter the Destination license plate number to which the product is going to be linked.

  3. Scan, select or enter the Destination location if the LPN is not yet assigned to any location.

  4. Scan, select or enter the Product to link to the LPN.

  5. Tap Next to display the list of the existing stock lines for the product. You can filter the list based on the selection filters displayed in the header. These filters are defined in the Mobile Automation setup function (FUNADCSEARCH). Refer to the Functional prerequisites.

  6. Select the checkbox for each stock line that you want to link to the LPN. To access the stock line details, enter a smaller quantity and select the stock details, tap the line.

  7. Tap Next when you have selected the stock lines and stock details to be linked to the LPN. You are automatically redirected to the initial page. The stock lines linked to the LPN are listed at the bottom of the screen. You are ready to complete one of the following actions:
    • Link another product to the same LPN, if this LPN is not defined in the License plate number function (GESLPN) as a single-product managed LPN: Repeat steps 4 to 7.

    • Validate the creation of the stock change document: Go to step 8.
    • Delete a line: Tap the delete icon.
  8. Tap Create to validate the stock change movement.

    • If you were able to proceed with the creation, the generated stock change number displays. The stock change document and its associated movements are created.

    • If you could not proceed with the creation, an error or information message displays.

      • Tap Go back to display the previous page.

      • Tap Cancel to delete all the stock changes.

Step by step

LPN linking initial page

   

Enter the LPN linking details.

  • The Change date defaults to today's date. You can change it until you tap Create and only to an earlier date. This date applies to all the changes performed in the same document.
  • The Site defined in the Site screen displays automatically. You cannot modify it on the current page.
  • Scan, select or enter the Destination license plate number to be linked to the products.
  • Scan, select or enter the Destination location if the selected destination license plate number is not yet linked to any location.

  • Scan, select or enter the Product to be linked to the LPN.

  • The first filter defined in the Mobile Automation setup function (FUNADCSEARCH) displays on this page: You can scan or enter a value to filter the stock lines on the next page. If you don't use this filter, it will display again along with the other filters on the next page.

Tap Next to display the Select stock page.

LPN linking - Select stock

Use this page to select the stock lines to be linked to the LPN.


The header displays the following information:

  • The selected destination LPN
  • The location linked to the LPN
  • The selected product code

The filters defined in the Mobile Automation setup function (FUNADCSEARCH) display here. Use them to filter the list of stock lines.

Note - informationThe filter displayed on the previous page displays only if you did not use it.

The list of stock lines displays.

Each stock line displays the following information:

  • Product code
  • The quantity to be linked to the LPN, related to the quantity in stock.

  • Information linked to the filters displayed in the header. In this example, the current location and the lot number.

 

You can perform the following actions:

  • Link the entire stock line: Select the checkbox.

  • Link a quantity smaller than the total quantity and select the stock details: Tap the line. The next LPN linking - Select stock page displays the stock details.

 

Tap Next to display the initial page with the selected stock lines to be linked to the LPN. You are ready to perform the following actions:

LPN linking - Select stock

When you tap a stock line, a page displays the stock details. You can enter a quantity smaller than the quantity in stock.

     

 
   
   
   
   
   
 

 

   
Update the quantity to link.
   

Depending on how the product is managed, you might need to select the related stock details.
For example, if the product is managed by global serial number, you need to select the range of serial numbers to be linked.

   
   
   
Keep or update the quantity to link.

Select the Starting serial number. The Ending serial number is automatically selected based on the quantity.

Note - errorOnly sequential serial numbers can be selected: The quantity you enter must be consistent with the range of serial numbers.
Tap the + icon to validate your selection and display a summary of the selected stock details.
     
   

 
   
   
   
   
   
   
   

A summary of the selected stock details is displayed. You can repeat the previous step:

  1. Add another quantity and another range of serial numbers.

  2. Tap the + icon to validate your selection

   
 

When you have selected all the serial numbers to link, tap one of the following actions:

  • Cancel to cancel the entered information and go back to the previous LPN linking - Select stock page.

  • Select to validate the entered information. The previous LPN linking - Select stock page displays. The checkbox for the stock line is automatically selected for the requested quantity.

Create the stock change document and generate stock movements

When you have selected all the stock lines along with the quantity and stock details, tap Next to display the initial page with the selected stock lines.

   
   

The list of LPNs in linking progress displays at the bottom of the page and provides the following information:

  • Number of stock lines to link to the LPN
  • List of product codes

You are ready to perform the following actions:

  • Add another product to the same LPN and same stock site. Repeat the same steps as defined previously.

  • Delete an LPN linking: Tap the delete icon

   

Tap Create when you have completed linking your LPNs and you are ready to validate the creation of the stock change document and generate the stock movements.

     

 

 

A GraphQL payload is sent to Sage X3. The data of this payload is mapped with the CWSLPNO import template which is called by the import-type AOWSIMPORT SOAP web service.

A message displays the generated document number.

 

When the stock change document and the stock movements are created, you can display the result in the following Sage X3 functions:

  • License plate number assignment function (GESLPNAFF)

  • Stock transactions inquiry (CONSSMV)

   
   

Limitations

The management rules are the same as in the License plate number assignment function (GESLPNAFF). There is no consistency control of the quantities of the selected stock lines and the filling capacity of the selected LPN.